Stored Procedures [dbo].[BAEEventSetupAddQuestion]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventSetupAddQuestion
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@eventCodevarchar(15)15
@functionCodevarchar(15)15
@questionvarchar(255)255
@questionTypevarchar(30)30
@requiredbit1
@questionorderint4
SQL Script
create procedure [dbo].[BAEEventSetupAddQuestion] @eventCode varchar(15),
     @functionCode varchar(15),
     @question varchar(255),
     @questionType varchar(30),
     @required bit,
     @questionorder int as
INSERT INTO EventSetupQuestion(EventCode, FunctionCode, Question,  QuestionType, Required,  QuestionOrder)
    VALUES(@eventCode, @functionCode, @question,  @questionType, @required, @questionorder);

    SELECT CAST(@@IDENTITY AS INT);

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved